package com.managementemployees.utils;

public class Constant {

	public static final String DATABASE_NAME = "DB_QLNV";
	public static final String TABLE_NHANVIEN = "tbl_NhanVien";
	public static String KEY_ID = "Id";
	public static final String KEY_TEN = "Ten";
	public static final String KEY_GIOITINH = "GioiTinh";
	public final static String KEY_NGAYSINH = "NgaySinh";

	public final static String TABLE_CONGVIEC = "tbl_CongViec";
	public final static String KEY_ID_CONGVIEC = "Id_CV";
	public final static String KEY_LOAI_CV = "Loai_CV";
	public final static String KEY_TIENLUONG = "TienLuong";
	public final static String KEY_TIENTHUONG = "TienThuong";

	public final static String TABLE_CHAMCONG = "tbl_ChamCong";
	public final static String KEY_NGAYLAM = "NgayLam";
	public final static String KEY_CASANG = "CaSang";
	public final static String KEY_CACCHIEU = "CaChieu";

	public static final String CREATE_TABLE_NHANVIEN = "CREATE TABLE "
			+ TABLE_NHANVIEN + "(" + KEY_ID
			+ " INTEGER PRIMARY KEY AUTOINCREMENT," + KEY_TEN + " TEXT,"
			+ KEY_GIOITINH + " NAVARCHAR(10)," + KEY_NGAYSINH
			+ " NAVARCHAR(15)," + KEY_ID_CONGVIEC + " INTEGER" + ")";

	public static final String CREATE_TABLE_CHAMCONG = "CREATE TABLE "
			+ TABLE_CONGVIEC + "(" + KEY_ID
			+ " INTEGER PRIMARY KEY AUTOINCREMENT," + KEY_LOAI_CV
			+ " VARCHAR(10)," + KEY_TIENLUONG + " FLOAT," + KEY_TIENTHUONG
			+ " FLOAT" + ")";
	public static final String CREATE_TABLE_BAOCAO = "CREATE TABLE "
			+ TABLE_CHAMCONG + "(" + KEY_ID
			+ " INTEGER PRIMARY KEY AUTOINCREMENT," + KEY_NGAYLAM
			+ " NVARCHAR(15)," + KEY_CASANG + " INTEGER," + KEY_CACCHIEU
			+ " INTEGER" + ")";
}
